package cn.btks.resultintegration.rule.repository;

import cn.btks.resultintegration.rule.pojo.Gyqyfszlyupfqkb;
import cn.btks.resultintegration.rule.pojo.Yswrwhdlzb;
import cn.btks.resultintegration.rule.pojo.Zdjgqyml;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;
import org.springframework.web.bind.annotation.PathVariable;

import java.util.List;

/**
 * @Author lijun
 * @Date 2021/10/15 15:12
 */
@Repository
public interface YswrwhdlzbRepository extends JpaRepository<Yswrwhdlzb,Long>, JpaSpecificationExecutor<Yswrwhdlzb> {

    /**
     * 多条件查询
     * @param sm
     * @param fl
     * @param wrw
     * @return
     */
    @Query(value = "select * from yswrwhdlzb where sm = ?1 and fl = ?2 and wrw = ?3",nativeQuery = true)
    Yswrwhdlzb findByConditions(String sm, String fl, String wrw);
}
